package cj.web.portal.dao;
/*
 *  
 *  
*/
import java.util.List;
import net.paoding.rose.jade.annotation.DAO;
import net.paoding.rose.jade.annotation.SQL;
import cj.web.kly.domain.Subject;

/**
 * 
 * @author 
 *
 */
@DAO
public interface SubjectVoDAO{
	
	@SQL("SELECT id,name,en,carouselImage,carouselImageMin,type FROM Subject WHERE deleteFlag=1 AND status =1 AND type=:1 ORDER BY orderNo LIMIT :2,:3 ")
    List<Subject> querySubject(int type,int start,int length);
	
	@SQL("SELECT id,name,en,carouselImage,carouselImageMin,type FROM Subject WHERE deleteFlag=1 AND status =1 ORDER BY orderNo LIMIT :1,:2 ")
    List<Subject> querySubject(int start,int length);
	
	@SQL("SELECT id,name,en,carouselImage,carouselImageMin,descs FROM Subject WHERE deleteFlag=1 AND id =:1 ")
    Subject queryById(int id);
}